Report shows only part of the calls for the day

[Igor]

Hello,

when I generate a report for the outbound calls for the day, only about 1000 or so calls are displayed, even though the CDR and CallEvent files show many more calls. In addition to suggesting a solution, can you please also suggest how I can construct a SQL statement to get the info on all calls from the database when I don't see all the calls in the report. Thank you. 

[SupportTeam]

Can you please advise which of the report are you referring to. PDF or CSV or HTML or the on-screen listing.

Were the calls loaded on same day? Or on a previous day?

A report for a particular day would show only those calls that had the "Time Scheduled" set for that day. "Time Scheduled" is the original "ActivateTime" / "Start Calls at:" time that was set when the call was loaded.

So usually calls loaded on some previous day, or with the original activate time set for some other day, would not be included.

But also note that you can load calls with "ActivateTime" / "Start Calls at:" set to whatever value you want, and that in turn will affect what calls are in report if you restrict reports to a particular day.

 

Often it's best to set the "Campaign Name" when loading calls, and then generate reports for that 'Campaign' instead of using just dates.

 

To view data on all the calls you can use this SQL command:

select * from calltrack

and to only show calls for a certain 'campaign' you can use this SQL:

select * from calltrack where CampaignName='mycampaign'

The 'calltrack' table is the table that stores the call outcome data for use in reports. The 'callque' table only stores calls that still need to  be made.

 

By default the database used to store calls details is a SQLite database in file: C:\Program Files (x86)\VoiceGuide\data\vgDb.db

You can use any SQLite database browser to view data in it. eg: https://sqlitebrowser.org